Drilldown
/cmd=1 /sample
/cmd=2
DrillDownDocument
<SolutionXML Name="DrillDownDocument"><DrillDownDocument DDWndState="134217729 -253 25 247 809 0" AddedInitCustomUI="1" DocID="{9785B8F5-4FB3-4215-94B2-43A085CA3A22}" DrilldownIx="2"><OptionMasters DDNodeID="15" InfoID="17" BreakdownID="16" TitleID="18" ConnectorID="19" DGMasterID="20" SIMasterID="-2"/><RecordsetBreakdownMap Count="18"><RBMapItem RecordsetID="1" GUID="{C2AD95CD-EAB1-463B-8873-BF454D7BF99B}" QueryID="1"/><RBMapItem RecordsetID="2" GUID="{8A705E05-B9A8-412A-9F9F-890598554930}" QueryID="2"/><RBMapItem RecordsetID="3" GUID="{1E7A15D1-B322-419D-B187-2A6A7355E38A}" QueryID="3"/><RBMapItem RecordsetID="4" GUID="{9916FB56-4DF3-45D1-B1EE-644F3713079B}" QueryID="4"/><RBMapItem RecordsetID="5" GUID="{6817BE08-1C3F-4930-A220-BACA57ECC972}" QueryID="5"/><RBMapItem RecordsetID="6" GUID="{FF95C2CB-4C45-46AC-BD06-66E124E82DFA}" QueryID="6"/><RBMapItem RecordsetID="7" GUID="{5826263A-C504-49C4-9062-BC4E1568F29B}" QueryID="7"/><RBMapItem RecordsetID="8" GUID="{30ABDA7F-6E16-490B-8FE4-7FEC3A364E60}" QueryID="8"/><RBMapItem RecordsetID="9" GUID="{D647CEC4-B7C0-49EF-937A-875B4ED1DB68}" QueryID="9"/><RBMapItem RecordsetID="10" GUID="{D5A9A47E-4443-44FF-A903-B92F789B0047}" QueryID="1"/><RBMapItem RecordsetID="11" GUID="{DF8C528A-C0C1-48F6-B494-EE4D61008ADC}" QueryID="2"/><RBMapItem RecordsetID="12" GUID="{C7B0CF0E-FA2F-47D4-87D1-7885DB64D253}" QueryID="3"/><RBMapItem RecordsetID="13" GUID="{1297C3EC-EDC9-4F79-A3C4-B0D7355D8440}" QueryID="4"/><RBMapItem RecordsetID="14" GUID="{9B44BB47-5225-4039-B8ED-15B93115BFB6}" QueryID="5"/><RBMapItem RecordsetID="15" GUID="{809B8776-2667-47F4-805D-2A4B149650BE}" QueryID="6"/><RBMapItem RecordsetID="16" GUID="{8D895F09-675C-4128-BBD5-1F6DAA59E33B}" QueryID="7"/><RBMapItem RecordsetID="17" GUID="{7E6DC01B-0E4E-4555-A44A-DDDA030D2C1E}" QueryID="8"/><RBMapItem RecordsetID="18" GUID="{19753BFA-9924-4408-AEEF-CAF785044B51}" QueryID="9"/></RecordsetBreakdownMap><DocOptions><Options><OptionFlags ShowTitle="1" ShowServerInfo="0" ShowConnectors="1" ShowBreakdown="1" ShowDataLegend="1" ShowFilters="1" ShowFirstN="1" AutoLayout="1" ShowMemberProps="0" FirstN="20" AutoRefresh="0" RefreshInterval="60"/></Options></DocOptions><Drilldowns Count="2"><Drilldown DrilldownIx="0" UseCount="1" ShownCount="1" LangID="1033" LocalizedSum="Sum" LocalizedAvg="Avg" LocalizedMin="Min" LocalizedMax="Max" LocalizedCount="Count" LeftBracket="(" RightBracket=")" LocalizedMember="Member" LocalizedRowCount="Count" BaseQueryString="&lt;SolutionXML&gt;&lt;qm:VisioQueryManager xmlns:qm=&quot;http://schemas.microsoft.com/visio/2005/QueryManager&quot;/&gt;&lt;Columns&gt;&lt;Column Field=&quot;Request ID&quot; Level=&quot;Request ID&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Request ID&quot; Level=&quot;Request ID&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Open Date&quot; Level=&quot;Open Date&quot; Operation=&quot;MIN&quot;/&gt;&lt;Column Field=&quot;Open Date&quot; Level=&quot;Open Date&quot; Operation=&quot;MAX&quot;/&gt;&lt;Column Field=&quot;Open Length&quot; Level=&quot;Open Length&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Open Length&quot; Level=&quot;Open Length&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Resumes Submitted&quot; Level=&quot;Resumes Submitted&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Resumes Submitted&quot; Level=&quot;Resumes Submitted&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Phone Screens&quot; Level=&quot;Phone Screens&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Phone Screens&quot; Level=&quot;Phone Screens&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Interviews&quot; Level=&quot;Interviews&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Interviews&quot; Level=&quot;Interviews&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Offers&quot; Level=&quot;Offers&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Offers&quot; Level=&quot;Offers&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Starts&quot; Level=&quot;Starts&quot; Operation=&quot;
SUM&quot;/&gt;&lt;Column Field=&quot;Starts&quot; Level=&quot;Starts&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Interviews/Offer&quot; Level=&quot;Interviews/Offer&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Interviews/Offer&quot; Level=&quot;Interviews/Offer&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Offer Accept Rate&quot; Level=&quot;Offer Accept Rate&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Offer Accept Rate&quot; Level=&quot;Offer Accept Rate&quot; Operation=&quot;AVG&quot;/&gt;&lt;/Columns&gt;&lt;Limit MaxReturn=&quot;20&quot; MaxReturnDir=&quot;TOP&quot; OverLimit=&quot;0&quot;/&gt;&lt;/SolutionXML&gt;" InfoID="2" PageID="0" ConnectedToRecordset="3" DGMasterID="2" SIMasterID="-2"><Options><OptionFlags ShowTitle="1" ShowServerInfo="0" ShowConnectors="1" ShowBreakdown="1" ShowDataLegend="1" ShowFilters="1" ShowFirstN="1" AutoLayout="1" ShowMemberProps="0" FirstN="20" AutoRefresh="0" RefreshInterval="60"/></Options><Columns Count="16"><Column FieldIx="0" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Request ID" DGMasterID="8" SIMasterID="24" Count="1"><Level ColumnName="Request ID" ActiveSet="0"><ColBDShapeIDs Count="2"><ShapeID Value="102"/><ShapeID Value="103"/></ColBDShapeIDs><SchemaID FieldIx="0" LevelIx="0"/></Level></Column><Column FieldIx="1" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Priority" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Priority" ActiveSet="0"><ColBDShapeIDs Count="1"><ShapeID Value="22"/></ColBDShapeIDs><SchemaID FieldIx="1" LevelIx="0"/></Level></Column><Column FieldIx="2" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Status" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Status" ActiveSet="0"><ColBDShapeIDs Count="1"><ShapeID Value="62"/></ColBDShapeIDs><SchemaID FieldIx="2" LevelIx="0"/></Level></Column><Column FieldIx="3" IsDimension="1" IsMeasure="1" Aggregations="12" ShownAggregations="0" ColumnName="Open Date" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Open Date" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="3" LevelIx="0"/></Level></Column><Column FieldIx="4" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Close Date" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Close Date" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="4" LevelIx="0"/></Level></Column><Column FieldIx="5" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="2" ColumnName="Open Length" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Open Length" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="5" LevelIx="0"/></Level></Column><Column FieldIx="6" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Division" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Division" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="6" LevelIx="0"/></Level></Column><Column FieldIx="7" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Job Title" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Job Title" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="7" LevelIx="0"/></Level></Column><Column FieldIx="8" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Recruiter" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Recruiter" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="8" LevelIx="0"/></Level></Column><Column FieldIx="9" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Resumes Submitted" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Resumes Submitted" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="9" LevelIx="0"/></Level></Column><Column FieldIx="10" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Phone Screens" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnN
ame="Phone Screens" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="10" LevelIx="0"/></Level></Column><Column FieldIx="11" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Interviews" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Interviews" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="11" LevelIx="0"/></Level></Column><Column FieldIx="12" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Offers" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Offers" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="12" LevelIx="0"/></Level></Column><Column FieldIx="13" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Starts" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Starts" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="13" LevelIx="0"/></Level></Column><Column FieldIx="14" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Interviews/Offer" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Interviews/Offer" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="14" LevelIx="0"/></Level></Column><Column FieldIx="15" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Offer Accept Rate" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Offer Accept Rate" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="15" LevelIx="0"/></Level></Column></Columns><Breakdowns Count="9"><Breakdown GUID="{C2AD95CD-EAB1-463B-8873-BF454D7BF99B}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="4" RecordsetID="1" QueryID="1" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="5"/></Breakdown><Breakdown GUID="{8A705E05-B9A8-412A-9F9F-890598554930}" GUIDFirstN="{1E7A15D1-B322-419D-B187-2A6A7355E38A}" ShapeID="22" RecordsetID="2" QueryID="2" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="23"/><ChildShape DDNodeID="36"/><ChildShape DDNodeID="48"/></Breakdown><Breakdown GUID="{1E7A15D1-B322-419D-B187-2A6A7355E38A}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="22" RecordsetID="3" QueryID="3" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{9916FB56-4DF3-45D1-B1EE-644F3713079B}" GUIDFirstN="{6817BE08-1C3F-4930-A220-BACA57ECC972}" ShapeID="62" RecordsetID="4" QueryID="4" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="63"/><ChildShape DDNodeID="76"/><ChildShape DDNodeID="88"/></Breakdown><Breakdown GUID="{6817BE08-1C3F-4930-A220-BACA57ECC972}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="62" RecordsetID="5" QueryID="5" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{FF95C2CB-4C45-46AC-BD06-66E124E82DFA}" GUIDFirstN="{5826263A-C504-49C4-9062-BC4E1568F29B}" ShapeID="102" RecordsetID="6" QueryID="6" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="104"/><ChildShape DDNodeID="117"/></Breakdown><Breakdown GUID="{5826263A-C504-49C4-9062-BC4E1568F29B}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="102" RecordsetID="7" QueryID="7" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{30ABDA7F-6E16-490B-8FE4-7FEC3A364E60}" GUIDFirstN="{D647CEC4-B7C0-49EF-937A-875B4ED1DB68}" ShapeID="103" RecordsetID="8" QueryID="8" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="130"/><ChildShape DDNodeID="143"/></Breakdown><Breakdown GUID="{D647CEC4-B7C0-49EF-937A-875B4ED1DB68}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="103" RecordsetID="9" QueryID="9" Merged="1" MergedDropped="0" IsFirstN="1"/></Breakdowns><GraphicItemVecMap Count="3"><GraphicItemVec Count="1" FieldIndex="0" Aggregation="1"><GraphicItemVecItem GraphicItemID="2" DGMasterID="21"/></GraphicItemVec><GraphicItemVec Count="1" FieldIndex="5" Aggregation="2"><GraphicItemVecItem GraphicItemID="3" DGMasterID="8"/></GraphicItemVec><GraphicItemVec Count="2" FieldIndex="100000" Aggregation="0"><GraphicItemVecItem GraphicItemID="3" DGMasterID="21"/><GraphicItemVecItem GraphicIte
mID="3" DGMasterID="2"/></GraphicItemVec></GraphicItemVecMap><BDShapeIDs Count="0"/></Drilldown><Drilldown DrilldownIx="1" UseCount="1" ShownCount="1" LangID="1033" LocalizedSum="Sum" LocalizedAvg="Avg" LocalizedMin="Min" LocalizedMax="Max" LocalizedCount="Count" LeftBracket="(" RightBracket=")" LocalizedMember="Member" LocalizedRowCount="Count" BaseQueryString="&lt;SolutionXML&gt;&lt;qm:VisioQueryManager xmlns:qm=&quot;http://schemas.microsoft.com/visio/2005/QueryManager&quot;/&gt;&lt;Columns&gt;&lt;Column Field=&quot;Request ID&quot; Level=&quot;Request ID&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Request ID&quot; Level=&quot;Request ID&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Open Date&quot; Level=&quot;Open Date&quot; Operation=&quot;MIN&quot;/&gt;&lt;Column Field=&quot;Open Date&quot; Level=&quot;Open Date&quot; Operation=&quot;MAX&quot;/&gt;&lt;Column Field=&quot;Open Length&quot; Level=&quot;Open Length&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Open Length&quot; Level=&quot;Open Length&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Resumes Submitted&quot; Level=&quot;Resumes Submitted&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Resumes Submitted&quot; Level=&quot;Resumes Submitted&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Phone Screens&quot; Level=&quot;Phone Screens&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Phone Screens&quot; Level=&quot;Phone Screens&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Interviews&quot; Level=&quot;Interviews&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Interviews&quot; Level=&quot;Interviews&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Offers&quot; Level=&quot;Offers&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Offers&quot; Level=&quot;Offers&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Starts&quot; Level=&quot;Starts&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Starts&quot; Level=&quot;Starts&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Interviews/Offer&quot; Level=&quot;Interviews/Offer&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Interviews/Offer&quot; Level=&quot;Interviews/Offer&quot; Operation=&quot;AVG&quot;/&gt;&lt;Column Field=&quot;Offer Accept Rate&quot; Level=&quot;Offer Accept Rate&quot; Operation=&quot;SUM&quot;/&gt;&lt;Column Field=&quot;Offer Accept Rate&quot; Level=&quot;Offer Accept Rate&quot; Operation=&quot;AVG&quot;/&gt;&lt;/Columns&gt;&lt;Limit MaxReturn=&quot;20&quot; MaxReturnDir=&quot;TOP&quot; OverLimit=&quot;0&quot;/&gt;&lt;/SolutionXML&gt;" InfoID="2" PageID="4" ConnectedToRecordset="3" DGMasterID="9" SIMasterID="-2"><Options><OptionFlags ShowTitle="1" ShowServerInfo="0" ShowConnectors="1" ShowBreakdown="1" ShowDataLegend="1" ShowFilters="1" ShowFirstN="1" AutoLayout="1" ShowMemberProps="0" FirstN="20" AutoRefresh="0" RefreshInterval="60"/></Options><Columns Count="16"><Column FieldIx="0" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Request ID" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Request ID" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="0" LevelIx="0"/></Level></Column><Column FieldIx="1" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Priority" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Priority" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="1" LevelIx="0"/></Level></Column><Column FieldIx="2" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Status" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Status" ActiveSet="0"><ColBDShapeIDs Count="1"><ShapeID Value="13"/></ColBDShapeIDs><SchemaID FieldIx="2" LevelIx="0"/></Level></Column><Column FieldIx="3" IsDimension="1" IsMeasure="1" Aggregations="12" ShownAggregations="0" ColumnName="Open Date" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Open Date" ActiveSet="0"><ColBDShapeIDs Count="0"/><Schem
aID FieldIx="3" LevelIx="0"/></Level></Column><Column FieldIx="4" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Close Date" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Close Date" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="4" LevelIx="0"/></Level></Column><Column FieldIx="5" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Open Length" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Open Length" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="5" LevelIx="0"/></Level></Column><Column FieldIx="6" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Division" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Division" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="6" LevelIx="0"/></Level></Column><Column FieldIx="7" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Job Title" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Job Title" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="7" LevelIx="0"/></Level></Column><Column FieldIx="8" IsDimension="1" IsMeasure="0" Aggregations="0" ShownAggregations="0" ColumnName="Recruiter" DGMasterID="10" SIMasterID="30" Count="1"><Level ColumnName="Recruiter" ActiveSet="0"><ColBDShapeIDs Count="3"><ShapeID Value="42"/><ShapeID Value="114"/><ShapeID Value="181"/></ColBDShapeIDs><SchemaID FieldIx="8" LevelIx="0"/></Level></Column><Column FieldIx="9" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Resumes Submitted" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Resumes Submitted" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="9" LevelIx="0"/></Level></Column><Column FieldIx="10" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Phone Screens" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Phone Screens" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="10" LevelIx="0"/></Level></Column><Column FieldIx="11" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Interviews" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Interviews" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="11" LevelIx="0"/></Level></Column><Column FieldIx="12" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Offers" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Offers" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="12" LevelIx="0"/></Level></Column><Column FieldIx="13" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Starts" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Starts" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="13" LevelIx="0"/></Level></Column><Column FieldIx="14" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Interviews/Offer" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Interviews/Offer" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="14" LevelIx="0"/></Level></Column><Column FieldIx="15" IsDimension="1" IsMeasure="1" Aggregations="3" ShownAggregations="0" ColumnName="Offer Accept Rate" DGMasterID="-1" SIMasterID="-1" Count="1"><Level ColumnName="Offer Accept Rate" ActiveSet="0"><ColBDShapeIDs Count="0"/><SchemaID FieldIx="15" LevelIx="0"/></Level></Column></Columns><Breakdowns Count="9"><Breakdown GUID="{D5A9A47E-4443-44FF-A903-B92F789B0047}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="4" RecordsetID="10" QueryID="1" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="5"/></Breakdown><Breakdown GUID="{DF8C528A-C0C1-48F6-B494-EE4D61008ADC}" GUIDFirstN="{C7B0CF0E-FA2F-47D4-87D1-7885DB64D253}" ShapeID="13" RecordsetID="11" QueryID="2" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="14"/><ChildShape DDNodeID="21"/><ChildShape DDNodeID="27"/></Breakdown><Breakdown GUID="{C7B0CF0E-FA2F-47D4-87D1-7885DB64
D253}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="13" RecordsetID="12" QueryID="3" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{1297C3EC-EDC9-4F79-A3C4-B0D7355D8440}" GUIDFirstN="{9B44BB47-5225-4039-B8ED-15B93115BFB6}" ShapeID="42" RecordsetID="13" QueryID="4" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="43"/><ChildShape DDNodeID="50"/><ChildShape DDNodeID="56"/></Breakdown><Breakdown GUID="{9B44BB47-5225-4039-B8ED-15B93115BFB6}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="42" RecordsetID="14" QueryID="5" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{809B8776-2667-47F4-805D-2A4B149650BE}" GUIDFirstN="{8D895F09-675C-4128-BBD5-1F6DAA59E33B}" ShapeID="114" RecordsetID="15" QueryID="6" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="115"/><ChildShape DDNodeID="116"/><ChildShape DDNodeID="158"/></Breakdown><Breakdown GUID="{8D895F09-675C-4128-BBD5-1F6DAA59E33B}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="114" RecordsetID="16" QueryID="7" Merged="1" MergedDropped="0" IsFirstN="1"/><Breakdown GUID="{7E6DC01B-0E4E-4555-A44A-DDDA030D2C1E}" GUIDFirstN="{19753BFA-9924-4408-AEEF-CAF785044B51}" ShapeID="181" RecordsetID="17" QueryID="8" Merged="0" MergedDropped="0" IsFirstN="0"><ChildShape DDNodeID="182"/><ChildShape DDNodeID="183"/><ChildShape DDNodeID="225"/><ChildShape DDNodeID="246"/></Breakdown><Breakdown GUID="{19753BFA-9924-4408-AEEF-CAF785044B51}" GUIDFirstN="{00000000-0000-0000-0000-000000000000}" ShapeID="181" RecordsetID="18" QueryID="9" Merged="1" MergedDropped="0" IsFirstN="1"/></Breakdowns><GraphicItemVecMap Count="2"><GraphicItemVec Count="1" FieldIndex="0" Aggregation="1"><GraphicItemVecItem GraphicItemID="2" DGMasterID="29"/></GraphicItemVec><GraphicItemVec Count="5" FieldIndex="100000" Aggregation="0"><GraphicItemVecItem GraphicItemID="3" DGMasterID="29"/><GraphicItemVecItem GraphicItemID="2" DGMasterID="9"/><GraphicItemVecItem GraphicItemID="2" DGMasterID="10"/><GraphicItemVecItem GraphicItemID="2" DGMasterID="13"/><GraphicItemVecItem GraphicItemID="2" DGMasterID="14"/></GraphicItemVec></GraphicItemVecMap><BDShapeIDs Count="0"/></Drilldown></Drilldowns></DrillDownDocument></SolutionXML>
vx:DataConnections
<vx:DataConnections NextID='3'><vx:DataConnection ID='1' FileName='' ConnectionString='Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=PRJMGT.XLS;Mode=Read;Extended Properties="HDR=YES;IMEX=1;MaxScanRows=0;Excel 12.0;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don&apos;t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False' Command='select * from `Recruiting$`' Timeout='300'/><vx:DataConnection ID='2' FileName='' ConnectionString='Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=PRJMGT.XLS;Mode=Read;Extended Properties="HDR=YES;IMEX=1;MaxScanRows=0;Excel 12.0;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don&apos;t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False' Command='select * from `Recruiting$`' Timeout='300'/></vx:DataConnections>
Icon Set
Flags
{Prop1}
{Open Length(Avg)}
Heading
FillColor FillColor
User.visDDTitle
Heading 1
Abc
esc(0)
0
Outline
Filled
Left
Up
Text Callout
AccentColor2
LineColor FillColor
{Count}
Text callout
Label
Left of Value
[Default]
Bottom
None
Data Bar
Data bar 1
Avg. Open Length
45
Interior
Top
Border
0.##
75
{Resumes Submitted(Avg)}
Resumes
23
{Phone Screens(Avg)}
Phone Screens
{Interviews(Avg)}
Interviews
{Interviews/Offer(Avg)}
Speedometer
Interviews/Offer
3
{Offer Accept Rate(Avg)}
Data bar 2
Offer Accept Rate
75%
<,%>0u
15
PivotDiagram
Drag the shape onto the drawing page to create new PivotDiagram.
Reposition Text
PivotDiagram,breakdown
Automatically generated when PivotDiagram created.
Reposition breakdown
Coll&apse
So&rt...
PivotDiagram,dynamic,connector,route,connect,line,combine,connection,association,conjunction,join
Human Resources,Human,Resources,HR,Personnel,Staff
Drag onto the page and then type to add text.
<no master>
Wireframe, UI, user,interface, prototype, mockup, Application, forms, dialogs, question icon
NonCFF
List
LegendContainer
OuterList
LegendContainer;NonCFF
Container
CalloutList;NonCFF
InnerList
IconItem
Person - Torso,Person,People,Human,Man
xmlns:vx
http://schemas.microsoft.com/visio/2006/extension
C:\Program Files\Microsoft Office\OFFICE14\visio content\1033\DRILLD_U.VSS
C:\Program Files\Microsoft Office\OFFICE14\visio content\1033\WFOBJ_U.VSS
C:\Program Files\Microsoft Office\OFFICE14\visio content\1033\WFDEP_U.VSS
Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=PRJMGT.XLS;Mode=Read;Extended Properties="HDR=YES;IMEX=1;MaxScanRows=0;Excel 12.0;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><SchemaField Name="Request ID" NameU="Request ID" Index="0" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Request ID" NameU="Request ID" DisplayName="Request ID" HierNameU="Request ID" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Priority" NameU="Priority" Index="1" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Priority" NameU="Priority" DisplayName="Priority" HierNameU="Priority" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Status" NameU="Status" Index="2" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Status" NameU="Status" DisplayName="Status" HierNameU="Status" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Open Date" NameU="Open Date" Index="3" Ordinal="0" Type="0" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Open Date" NameU="Open Date" DisplayName="Open Date" HierNameU="Open Date" ShortName="" Index="0" Type="7" AggType="0"/></SchemaField><SchemaField Name="Close Date" NameU="Close Date" Index="4" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Close Date" NameU="Close Date" DisplayName="Close Date" HierNameU="Close Date" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Open Length" NameU="Open Length" Index="5" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Open Length" NameU="Open Length" DisplayName="Open Length" HierNameU="Open Length" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Division" NameU="Division" Index="6" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Division" NameU="Division" DisplayName="Division" HierNameU="Division" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Job Title" NameU="Job Title" Index="7" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Job Title" NameU="Job Title" DisplayName="Job Title" HierNameU="Job Title" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Recruiter" NameU="Recruiter" Index="8" Ordinal="0" Type="0" TypeChangeable="0" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Recruiter" NameU="Recruiter" DisplayName="Recruiter" HierNameU="Recruiter" ShortName="" Index="0" Type="202" AggType="0"/></SchemaField><SchemaField Name="Resumes Submitted" NameU="Resumes Submitted" Index="9" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Resumes Submitted" NameU="Resumes Submitted" DisplayName="Resumes Submitted" HierNameU="Resumes Submitted" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Phone Screens" NameU="Phone Screens" Index="10" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Phone Screens" NameU="Phone Screens" DisplayName="Phone Screens" HierNameU="Phone Screens" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Interviews" NameU="Interviews" Index="11" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Interviews" NameU="Interviews" DisplayName="Interviews" HierNameU="Interviews" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Offers" NameU="Offers" Index="12" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Offers" NameU="Offers" DisplayName="Offers" HierNameU="Offers" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Starts" NameU="Starts" Index="13" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Starts" NameU="Starts" DisplayName="Starts" HierNameU="Starts" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Interviews/Offer" NameU="Interviews/Offer" Index="14" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Interviews/Offer" NameU="Interviews/Offer" DisplayName="Interviews/Offer" HierNameU="Interviews/Offer" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SchemaField Name="Offer Accept Rate" NameU="Offer Accept Rate" Index="15" Ordinal="0" Type="1" TypeChangeable="1" TimeDimension="0" DefaultMember="" Levels="1" Provider="1" DBType="4"><SchemaLevel Name="Offer Accept Rate" NameU="Offer Accept Rate" DisplayName="Offer Accept Rate" HierNameU="Offer Accept Rate" ShortName="" Index="0" Type="5" AggType="0"/></SchemaField><SourceInfo FullPathName="PRJMGT.XLS" ServerName="" DatabaseName="" CountColumnName="Count" MemberColumnName="Member" LastModified="8/31/2009 3:50:16 PM"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><SchemaField Name=""Request ID"" NameU=""Request ID"" Index=""0"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Request ID"" NameU=""Request ID"" DisplayName=""Request ID"" HierNameU=""Request ID"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Priority"" NameU=""Priority"" Index=""1"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Priority"" NameU=""Priority"" DisplayName=""Priority"" HierNameU=""Priority"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Status"" NameU=""Status"" Index=""2"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Status"" NameU=""Status"" DisplayName=""Status"" HierNameU=""Status"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Open Date"" NameU=""Open Date"" Index=""3"" Ordinal=""0"" Type=""0"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Open Date"" NameU=""Open Date"" DisplayName=""Open Date"" HierNameU=""Open Date"" ShortName="""" Index=""0"" Type=""7"" AggType=""0""/></SchemaField><SchemaField Name=""Close Date"" NameU=""Close Date"" Index=""4"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Close Date"" NameU=""Close Date"" DisplayName=""Close Date"" HierNameU=""Close Date"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Open Length"" NameU=""Open Length"" Index=""5"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Open Length"" NameU=""Open Length"" DisplayName=""Open Length"" HierNameU=""Open Length"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Division"" NameU=""Division"" Index=""6"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Division"" NameU=""Division"" DisplayName=""Division"" HierNameU=""Division"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Job Title"" NameU=""Job Title"" Index=""7"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Job Title"" NameU=""Job Title"" DisplayName=""Job Title"" HierNameU=""Job Title"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Recruiter"" NameU=""Recruiter"" Index=""8"" Ordinal=""0"" Type=""0"" TypeChangeable=""0"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Recruiter"" NameU=""Recruiter"" DisplayName=""Recruiter"" HierNameU=""Recruiter"" ShortName="""" Index=""0"" Type=""202"" AggType=""0""/></SchemaField><SchemaField Name=""Resumes Submitted"" NameU=""Resumes Submitted"" Index=""9"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Resumes Submitted"" NameU=""Resumes Submitted"" DisplayName=""Resumes Submitted"" HierNameU=""Resumes Submitted"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Phone Screens"" NameU=""Phone Screens"" Index=""10"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Phone Screens"" NameU=""Phone Screens"" DisplayName=""Phone Screens"" HierNameU=""Phone Screens"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Interviews"" NameU=""Interviews"" Index=""11"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Interviews"" NameU=""Interviews"" DisplayName=""Interviews"" HierNameU=""Interviews"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Offers"" NameU=""Offers"" Index=""12"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Offers"" NameU=""Offers"" DisplayName=""Offers"" HierNameU=""Offers"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Starts"" NameU=""Starts"" Index=""13"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Starts"" NameU=""Starts"" DisplayName=""Starts"" HierNameU=""Starts"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Interviews/Offer"" NameU=""Interviews/Offer"" Index=""14"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Interviews/Offer"" NameU=""Interviews/Offer"" DisplayName=""Interviews/Offer"" HierNameU=""Interviews/Offer"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SchemaField Name=""Offer Accept Rate"" NameU=""Offer Accept Rate"" Index=""15"" Ordinal=""0"" Type=""1"" TypeChangeable=""1"" TimeDimension=""0"" DefaultMember="""" Levels=""1"" Provider=""1"" DBType=""4""><SchemaLevel Name=""Offer Accept Rate"" NameU=""Offer Accept Rate"" DisplayName=""Offer Accept Rate"" HierNameU=""Offer Accept Rate"" ShortName="""" Index=""0"" Type=""5"" AggType=""0""/></SchemaField><SourceInfo FullPathName=""PRJMGT.XLS"" ServerName="""" DatabaseName="""" CountColumnName=""Count"" MemberColumnName=""Member"" LastModified=""8/31/2009 3:50:16 PM""/></SolutionXML>
Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=PRJMGT.XLS;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;MaxScanRows=0;Excel 12.0;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False
select * from `Recruiting$`
{9785B8F5-4FB3-4215-94B2-43A085CA3A22}
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/></SolutionXML>
Reposition Data Graphic
(empty)
Total
16
255
29
Count
Confi&gure Column...
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Axis Field="Priority" Level="Priority"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Axis Field="Priority" Level="Priority"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Axis Field=""Priority"" Level=""Priority""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Axis Field=""Priority"" Level=""Priority""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
High
17
5
Low
19
7
Medium
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Status" Level="Status"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Status" Level="Status"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Status"" Level=""Status""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Status"" Level=""Status""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
4
1
Offered
26
2
Open
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Offered" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Request ID" Level="Request ID"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Offered" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Request ID" Level="Request ID"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Offered"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Request ID"" Level=""Request ID""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Offered"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Request ID"" Level=""Request ID""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Open" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Request ID" Level="Request ID"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Priority" Level="Priority"><FilterClause Operator="EQUAL_SEL" Value="High" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Open" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Request ID" Level="Request ID"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Open"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Request ID"" Level=""Request ID""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Priority"" Level=""Priority""><FilterClause Operator=""EQUAL_SEL"" Value=""High"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Open"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Request ID"" Level=""Request ID""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
Human resources
6
13
21
24051
25
30
24074
10
24182
9
33
24304
Legend
CalloutList
greater than 20 days
15-20 days
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Axis Field="Status" Level="Status"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Axis Field="Status" Level="Status"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Axis Field=""Status"" Level=""Status""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Axis Field=""Status"" Level=""Status""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
70%
2.05
2.74
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Filled" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Filled" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Filled"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Filled"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
Kari Furse
Person - torso
63%
1.25
Sabine Royant
100%
Yan Li
1.88
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Offered" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Offered" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Offered"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Offered"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
Mark Hassall
3.53
2.33
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Open" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm="http://schemas.microsoft.com/visio/2005/QueryManager"/><Filters><Filter Field="Status" Level="Status"><FilterClause Operator="EQUAL_SEL" Value="Open" Linkage="AND" DisplayValue="" ParenBefore="0" ParenAfter="0"/></Filter></Filters><Axis Field="Recruiter" Level="Recruiter"/><Limit MaxReturn="-1" MaxReturnDir="TOP" OverLimit="1"/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Open"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/></SolutionXML>
<SolutionXML><qm:VisioQueryManager xmlns:qm=""http://schemas.microsoft.com/visio/2005/QueryManager""/><Filters><Filter Field=""Status"" Level=""Status""><FilterClause Operator=""EQUAL_SEL"" Value=""Open"" Linkage=""AND"" DisplayValue="""" ParenBefore=""0"" ParenAfter=""0""/></Filter></Filters><Axis Field=""Recruiter"" Level=""Recruiter""/><Limit MaxReturn=""-1"" MaxReturnDir=""TOP"" OverLimit=""1""/></SolutionXML>
20
27
12
vx:DataRecordSets
<vx:DataRecordSets NextID='19' ActiveRecordsetID='0'><vx:DataRecordSet ID='1' ConnectionID='1' Command='SELECT distinct TOP 20 COUNT(*) AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offers]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$`' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='Recruiting$' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='626264194'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly" rs:updatable="true">
<s:AttributeType name="c0" rs:name="_Visio_RowID_" rs:number="1" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:datatype dt:type="int" dt:maxLength="4" rs:precision="0" rs:fixedlength="true"/>
</s:AttributeType>
<s:AttributeType name="Member" rs:number="2" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="Count" rs:number="3" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c3" rs:name="Request ID" rs:number="4" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:datatype dt:type="float" dt:maxLength="8" rs:precision="0" rs:fixedlength="true"/>
<s:AttributeType name="c4" rs:name="Request ID(Avg)" rs:number="5" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c5" rs:name="Open Date(Min)" rs:number="6" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rs:precision="0" rs:fixedlength="true"/>
<s:AttributeType name="c6" rs:name="Open Date(Max)" rs:number="7" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c7" rs:name="Open Length" rs:number="8" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c8" rs:name="Open Length(Avg)" rs:number="9" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c9" rs:name="Resumes Submitted" rs:number="10" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c10" rs:name="Resumes Submitted(Avg)" rs:number="11" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c11" rs:name="Phone Screens" rs:number="12" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c12" rs:name="Phone Screens(Avg)" rs:number="13" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="Interviews" rs:number="14" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c14" rs:name="Interviews(Avg)" rs:number="15" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="Offers" rs:number="16" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c16" rs:name="Offers(Avg)" rs:number="17" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="Starts" rs:number="18" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c18" rs:name="Starts(Avg)" rs:number="19" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c19" rs:name="Interviews/Offer" rs:number="20" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c20" rs:name="Interviews/Offer(Avg)" rs:number="21" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c21" rs:name="Offer Accept Rate" rs:number="22" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:AttributeType name="c22" rs:name="Offer Accept Rate(Avg)" rs:number="23" rs:nullable="true" rs:maydefer="true" rs:write="true">
<s:extends type="rs:rowbase"/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row c0="1" Member="29" Count="29" c3="701449" c4="24187.896551724138" c5="2009-04-01T00:00:00" c6="2009-04-30T00:00:00" c7="469" c8="16.172413793103448" c9="659" c10="22.724137931034484" c11="285" c12="9.8275862068965516" Interviews="119" c14="4.1034482758620694" Offers="36" c16="1.2413793103448276" Starts="5" c18="0.17241379310344829" c19="59.920000000000002" c20="2.0662068965517242" c21="3.5" c22="0.1206896551724138"/>
</rs:data>
</xml>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:RowMap RowID='1' PageID='0' ShapeID='5'/></vx:DataRecordSet><vx:DataRecordSet ID='2' ConnectionID='1' Command='SELECT distinct TOP 20 [Priority] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([I
nterviews]) as [Interviews(Avg)],SUM([Offers]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` GROUP BY [Priority] ORDER BY [Priority] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-2' NextRowID='4' RefreshNoReconciliationUI='1' Checksum='3200312753'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:datatype dt:type="string" dt:maxLength="255" rs:precision="0"/>
<z:row c0="1" Member="High" Count="5" c3="120624" c4="24124.799999999999" c5="2009-04-01T00:00:00" c6="2009-04-17T00:00:00" c7="86" c8="17.199999999999999" c9="93" c10="18.600000000000001" c11="52" c12="10.4" Interviews="20" c14="4" Offers="5" c16="1" Starts="1" c18="0.20000000000000001" c19="13.5" c20="2.7000000000000002" c21="1" c22="0.20000000000000001"/>
<z:row c0="2" Member="Low" Count="7" c3="169440" c4="24205.714285714286" c5="2009-04-03T00:00:00" c6="2009-04-27T00:00:00" c7="135" c8="19.285714285714285" c9="190" c10="27.142857142857142" c11="64" c12="9.1428571428571423" Interviews="29" c14="4.1428571428571432" Offers="7" c16="1" Starts="1" c18="0.14285714285714285" c19="20" c20="2.8571428571428572" c21="1" c22="0.14285714285714285"/>
<z:row c0="3" Member="Medium" Count="17" c3="411385" c4="24199.117647058825" c5="2009-04-02T00:00:00" c6="2009-04-30T00:00:00" c7="248" c8="14.588235294117647" c9="376" c10="22.117647058823529" c11="169" c12="9.9411764705882355" Interviews="70" c14="4.117647058823529" Offers="24" c16="1.411764705882353" Starts="3" c18="0.17647058823529413" c19="26.420000000000002" c20="1.5541176470588236" c21="1.5" c22="8.8235294117647065E-2"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='0' ShapeID='23'/><vx:RowMap RowID='2' PageID='0' ShapeID='36'/><vx:RowMap RowID='3' PageID='0' ShapeID='48'/></vx:DataRecordSet><vx:DataRecordSet ID='3' ConnectionID='1' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[Ph
one Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$`) AS A left outer join (SELECT TOP 20 [Priority] AS [Member] FROM `Recruiting$` GROUP BY [Priority] ORDER BY [Priority] ASC) AS B ON A.[Priority] = B.[Member] where (A.[Priority] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-3' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='4170967662'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="0" Count="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='4' ConnectionID='1' Command='SELECT distinct TOP 20 [Status] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offers])
as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) GROUP BY [Status] ORDER BY [Status] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-4' NextRowID='4' RefreshNoReconciliationUI='1' Checksum='3979958071'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="Filled" Count="1" c3="24013" c4="24013" c5="2009-04-17T00:00:00" c6="2009-04-17T00:00:00" c7="4" c8="4" c9="5" c10="5" c11="2" c12="2" Interviews="1" c14="1" Offers="1" c16="1" Starts="1" c18="1" c19="1" c20="1" c21="1" c22="1"/>
<z:row c0="2" Member="Offered" Count="2" c3="48125" c4="24062.5" c5="2009-04-01T00:00:00" c6="2009-04-10T00:00:00" c7="51" c8="25.5" c9="38" c10="19" c11="21" c12="10.5" Interviews="7" c14="3.5" Offers="1" c16="0.5" Starts="0" c18="0" c19="5" c20="2.5" c21="0" c22="0"/>
<z:row c0="3" Member="Open" Count="2" c3="48486" c4="24243" c5="2009-04-15T00:00:00" c6="2009-04-16T00:00:00" c7="31" c8="15.5" c9="50" c10="25" c11="29" c12="14.5" Interviews="12" c14="6" Offers="3" c16="1.5" Starts="0" c18="0" c19="7.5" c20="3.75" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='0' ShapeID='63'/><vx:RowMap RowID='2' PageID='0' ShapeID='76'/><vx:RowMap RowID='3' PageID='0' ShapeID='88'/></vx:DataRecordSet><vx:DataRecordSet ID='5' ConnectionID='1' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[Ph
one Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; )) AS A left outer join (SELECT TOP 20 [Status] AS [Member] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) GROUP BY [Status] ORDER BY [Status] ASC) AS B ON A.[Status] = B.[Member] where (A.[Status] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-5' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='4013545914'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='6' ConnectionID='1' Command='SELECT distinct TOP 20 [Request ID] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offer
s]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Offered&apos; ) GROUP BY [Request ID] ORDER BY [Request ID] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-6' NextRowID='3' RefreshNoReconciliationUI='1' Checksum='2204795840'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="24051" Count="1" c3="24051" c4="24051" c5="2009-04-10T00:00:00" c6="2009-04-10T00:00:00" c7="21" c8="21" c9="13" c10="13" c11="6" c12="6" Interviews="2" c14="2" Offers="0" c16="0" Starts="0" c18="0" c19="0" c20="0" c21="0" c22="0"/>
<z:row c0="2" Member="24074" Count="1" c3="24074" c4="24074" c5="2009-04-01T00:00:00" c6="2009-04-01T00:00:00" c7="30" c8="30" c9="25" c10="25" c11="15" c12="15" Interviews="5" c14="5" Offers="1" c16="1" Starts="0" c18="0" c19="5" c20="5" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='0' ShapeID='104'/><vx:RowMap RowID='2' PageID='0' ShapeID='117'/></vx:DataRecordSet><vx:DataRecordSet ID='7' ConnectionID='1' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[Phone Screens]) as [Phone Screens
],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Offered&apos; )) AS A left outer join (SELECT TOP 20 [Request ID] AS [Member] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Offered&apos; ) GROUP BY [Request ID] ORDER BY [Request ID] ASC) AS B ON A.[Request ID] = B.[Member] where (A.[Request ID] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-7' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='1994259312'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='8' ConnectionID='1' Command='SELECT distinct TOP 20 [Request ID] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offer
s]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Open&apos; ) GROUP BY [Request ID] ORDER BY [Request ID] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-8' NextRowID='3' RefreshNoReconciliationUI='1' Checksum='3049011351'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="24182" Count="1" c3="24182" c4="24182" c5="2009-04-16T00:00:00" c6="2009-04-16T00:00:00" c7="15" c8="15" c9="17" c10="17" c11="10" c12="10" Interviews="3" c14="3" Offers="1" c16="1" Starts="0" c18="0" c19="3" c20="3" c21="0" c22="0"/>
<z:row c0="2" Member="24304" Count="1" c3="24304" c4="24304" c5="2009-04-15T00:00:00" c6="2009-04-15T00:00:00" c7="16" c8="16" c9="33" c10="33" c11="19" c12="19" Interviews="9" c14="9" Offers="2" c16="2" Starts="0" c18="0" c19="4.5" c20="4.5" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='0' ShapeID='130'/><vx:RowMap RowID='2' PageID='0' ShapeID='143'/></vx:DataRecordSet><vx:DataRecordSet ID='9' ConnectionID='1' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[Phone Screens]) as [Phone Screens
],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Open&apos; )) AS A left outer join (SELECT TOP 20 [Request ID] AS [Member] FROM `Recruiting$` WHERE ([Priority] = &apos;High&apos; ) AND ([Status] = &apos;Open&apos; ) GROUP BY [Request ID] ORDER BY [Request ID] ASC) AS B ON A.[Request ID] = B.[Member] where (A.[Request ID] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:46' Name='DataRecordset-9' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='2357658260'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='10' ConnectionID='2' Command='SELECT distinct TOP 20 COUNT(*) AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offers]
) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$`' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='Recruiting$-2' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='2122314025'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:RowMap RowID='1' PageID='4' ShapeID='5'/></vx:DataRecordSet><vx:DataRecordSet ID='11' ConnectionID='2' Command='SELECT distinct TOP 20 [Status] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([In
terviews]) as [Interviews(Avg)],SUM([Offers]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` GROUP BY [Status] ORDER BY [Status] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-11' NextRowID='4' RefreshNoReconciliationUI='1' Checksum='205100355'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="Filled" Count="5" c3="120691" c4="24138.200000000001" c5="2009-04-03T00:00:00" c6="2009-04-26T00:00:00" c7="47" c8="9.4000000000000004" c9="92" c10="18.399999999999999" c11="37" c12="7.4000000000000004" Interviews="23" c14="4.5999999999999996" Offers="11" c16="2.2000000000000002" Starts="5" c18="1" c19="10.25" c20="2.0499999999999998" c21="3.5" c22="0.69999999999999996"/>
<z:row c0="2" Member="Offered" Count="9" c3="218231" c4="24247.888888888891" c5="2009-04-01T00:00:00" c6="2009-04-30T00:00:00" c7="134" c8="14.888888888888889" c9="225" c10="25" c11="104" c12="11.555555555555555" Interviews="39" c14="4.333333333333333" Offers="11" c16="1.2222222222222223" Starts="0" c18="0" c19="24.670000000000002" c20="2.7411111111111115" c21="0" c22="0"/>
<z:row c0="3" Member="Open" Count="15" c3="362527" c4="24168.466666666667" c5="2009-04-02T00:00:00" c6="2009-04-27T00:00:00" c7="288" c8="19.199999999999999" c9="342" c10="22.800000000000001" c11="144" c12="9.5999999999999996" Interviews="57" c14="3.7999999999999998" Offers="14" c16="0.93333333333333335" Starts="0" c18="0" c19="25" c20="1.6666666666666667" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='4' ShapeID='14'/><vx:RowMap RowID='2' PageID='4' ShapeID='21'/><vx:RowMap RowID='3' PageID='4' ShapeID='27'/></vx:DataRecordSet><vx:DataRecordSet ID='12' ConnectionID='2' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[P
hone Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$`) AS A left outer join (SELECT TOP 20 [Status] AS [Member] FROM `Recruiting$` GROUP BY [Status] ORDER BY [Status] ASC) AS B ON A.[Status] = B.[Member] where (A.[Status] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-12' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='511770984'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='13' ConnectionID='2' Command='SELECT distinct TOP 20 [Recruiter] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offer
s]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Status] = &apos;Filled&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-13' NextRowID='4' RefreshNoReconciliationUI='1' Checksum='1002501819'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="Kari Furse" Count="2" c3="48334" c4="24167" c5="2009-04-17T00:00:00" c6="2009-04-26T00:00:00" c7="9" c8="4.5" c9="28" c10="14" c11="11" c12="5.5" Interviews="7" c14="3.5" Offers="5" c16="2.5" Starts="2" c18="1" c19="2.5" c20="1.25" c21="1.25" c22="0.625"/>
<z:row c0="2" Member="Sabine Royant" Count="1" c3="24058" c4="24058" c5="2009-04-03T00:00:00" c6="2009-04-03T00:00:00" c7="25" c8="25" c9="29" c10="29" c11="6" c12="6" Interviews="4" c14="4" Offers="1" c16="1" Starts="1" c18="1" c19="4" c20="4" c21="1" c22="1"/>
<z:row c0="3" Member="Yan Li" Count="2" c3="48299" c4="24149.5" c5="2009-04-04T00:00:00" c6="2009-04-15T00:00:00" c7="13" c8="6.5" c9="35" c10="17.5" c11="20" c12="10" Interviews="12" c14="6" Offers="5" c16="2.5" Starts="2" c18="1" c19="3.75" c20="1.875" c21="1.25" c22="0.625"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='4' ShapeID='43'/><vx:RowMap RowID='2' PageID='4' ShapeID='50'/><vx:RowMap RowID='3' PageID='4' ShapeID='56'/></vx:DataRecordSet><vx:DataRecordSet ID='14' ConnectionID='2' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A.[P
hone Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Status] = &apos;Filled&apos; )) AS A left outer join (SELECT TOP 20 [Recruiter] AS [Member] FROM `Recruiting$` WHERE ([Status] = &apos;Filled&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC) AS B ON A.[Recruiter] = B.[Member] where (A.[Recruiter] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-14' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='1728386141'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='15' ConnectionID='2' Command='SELECT distinct TOP 20 [Recruiter] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offer
s]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Status] = &apos;Offered&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-15' NextRowID='4' RefreshNoReconciliationUI='1' Checksum='1355621862'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="Kari Furse" Count="1" c3="24399" c4="24399" c5="2009-04-22T00:00:00" c6="2009-04-22T00:00:00" c7="9" c8="9" c9="13" c10="13" c11="3" c12="3" Interviews="1" c14="1" Offers="0" c16="0" Starts="0" c18="0" c19="0" c20="0" c21="0" c22="0"/>
<z:row c0="2" Member="Mark Hassall" Count="5" c3="121479" c4="24295.799999999999" c5="2009-04-07T00:00:00" c6="2009-04-30T00:00:00" c7="71" c8="14.199999999999999" c9="147" c10="29.399999999999999" c11="63" c12="12.6" Interviews="25" c14="5" Offers="7" c16="1.3999999999999999" Starts="0" c18="0" c19="17.670000000000002" c20="3.5340000000000003" c21="0" c22="0"/>
<z:row c0="3" Member="Sabine Royant" Count="3" c3="72353" c4="24117.666666666668" c5="2009-04-01T00:00:00" c6="2009-04-28T00:00:00" c7="54" c8="18" c9="65" c10="21.666666666666668" c11="38" c12="12.666666666666666" Interviews="13" c14="4.333333333333333" Offers="4" c16="1.3333333333333333" Starts="0" c18="0" c19="7" c20="2.3333333333333335" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='4' ShapeID='115'/><vx:RowMap RowID='2' PageID='4' ShapeID='116'/><vx:RowMap RowID='3' PageID='4' ShapeID='158'/></vx:DataRecordSet><vx:DataRecordSet ID='16' ConnectionID='2' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resumes Submitted]) as [Resumes Submitted(Avg)],SUM(A
.[Phone Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Status] = &apos;Offered&apos; )) AS A left outer join (SELECT TOP 20 [Recruiter] AS [Member] FROM `Recruiting$` WHERE ([Status] = &apos;Offered&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC) AS B ON A.[Recruiter] = B.[Member] where (A.[Recruiter] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-16' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='2107583200'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet><vx:DataRecordSet ID='17' ConnectionID='2' Command='SELECT distinct TOP 20 [Recruiter] AS [Member], COUNT(*) AS [Count], SUM([Request ID]) as [Request ID],AVG([Request ID]) as [Request ID(Avg)],MIN([Open Date]) as [Open Date(Min)],MAX([Open Date]) as [Open Date(Max)],SUM([Open Length]) as [Open Length],AVG([Open Length]) as [Open Length(Avg)],SUM([Resumes Submitted]) as [Resumes Submitted],AVG([Resumes Submitted]) as [Resumes Submitted(Avg)],SUM([Phone Screens]) as [Phone Screens],AVG([Phone Screens]) as [Phone Screens(Avg)],SUM([Interviews]) as [Interviews],AVG([Interviews]) as [Interviews(Avg)],SUM([Offer
s]) as [Offers],AVG([Offers]) as [Offers(Avg)],SUM([Starts]) as [Starts],AVG([Starts]) as [Starts(Avg)],SUM([Interviews/Offer]) as [Interviews/Offer],AVG([Interviews/Offer]) as [Interviews/Offer(Avg)],SUM([Offer Accept Rate]) as [Offer Accept Rate],AVG([Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM `Recruiting$` WHERE ([Status] = &apos;Open&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-17' NextRowID='5' RefreshNoReconciliationUI='1' Checksum='613858290'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<z:row c0="1" Member="Kari Furse" Count="1" c3="24040" c4="24040" c5="2009-04-09T00:00:00" c6="2009-04-09T00:00:00" c7="22" c8="22" c9="29" c10="29" c11="7" c12="7" Interviews="2" c14="2" Offers="1" c16="1" Starts="0" c18="0" c19="2" c20="2" c21="0" c22="0"/>
<z:row c0="2" Member="Mark Hassall" Count="9" c3="217654" c4="24183.777777777777" c5="2009-04-02T00:00:00" c6="2009-04-19T00:00:00" c7="184" c8="20.444444444444443" c9="181" c10="20.111111111111111" c11="85" c12="9.4444444444444446" Interviews="35" c14="3.8888888888888888" Offers="9" c16="1" Starts="0" c18="0" c19="17" c20="1.8888888888888888" c21="0" c22="0"/>
<z:row c0="3" Member="Sabine Royant" Count="1" c3="24163" c4="24163" c5="2009-04-03T00:00:00" c6="2009-04-03T00:00:00" c7="28" c8="28" c9="27" c10="27" c11="6" c12="6" Interviews="3" c14="3" Offers="0" c16="0" Starts="0" c18="0" c19="0" c20="0" c21="0" c22="0"/>
<z:row c0="4" Member="Yan Li" Count="4" c3="96670" c4="24167.5" c5="2009-04-08T00:00:00" c6="2009-04-27T00:00:00" c7="54" c8="13.5" c9="105" c10="26.25" c11="46" c12="11.5" Interviews="17" c14="4.25" Offers="4" c16="1" Starts="0" c18="0" c19="6" c20="1.5" c21="0" c22="0"/>
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns><vx:PrimaryKey>Member</vx:PrimaryKey><vx:RowMap RowID='1' PageID='4' ShapeID='182'/><vx:RowMap RowID='2' PageID='4' ShapeID='183'/><vx:RowMap RowID='3' PageID='4' ShapeID='225'/><vx:RowMap RowID='4' PageID='4' ShapeID='246'/></vx:DataRecordSet><vx:DataRecordSet ID='18' ConnectionID='2' Command='SELECT COUNT(*) AS [Member], COUNT(*) AS [Count], SUM(A.[Request ID]) as [Request ID],AVG(A.[Request ID]) as [Request ID(Avg)],MIN(A.[Open Date]) as [Open Date(Min)],MAX(A.[Open Date]) as [Open Date(Max)],SUM(A.[Open Length]) as [Open Length],AVG(A.[Open Length]) as [Open Length(Avg)],SUM(A.[Resumes Submitted]) as [Resumes Submitted],AVG(A.[Resume
s Submitted]) as [Resumes Submitted(Avg)],SUM(A.[Phone Screens]) as [Phone Screens],AVG(A.[Phone Screens]) as [Phone Screens(Avg)],SUM(A.[Interviews]) as [Interviews],AVG(A.[Interviews]) as [Interviews(Avg)],SUM(A.[Offers]) as [Offers],AVG(A.[Offers]) as [Offers(Avg)],SUM(A.[Starts]) as [Starts],AVG(A.[Starts]) as [Starts(Avg)],SUM(A.[Interviews/Offer]) as [Interviews/Offer],AVG(A.[Interviews/Offer]) as [Interviews/Offer(Avg)],SUM(A.[Offer Accept Rate]) as [Offer Accept Rate],AVG(A.[Offer Accept Rate]) as [Offer Accept Rate(Avg)] FROM (SELECT * FROM `Recruiting$` WHERE ([Status] = &apos;Open&apos; )) AS A left outer join (SELECT TOP 20 [Recruiter] AS [Member] FROM `Recruiting$` WHERE ([Status] = &apos;Open&apos; ) GROUP BY [Recruiter] ORDER BY [Recruiter] ASC) AS B ON A.[Recruiter] = B.[Member] where (A.[Recruiter] IS NOT NULL AND B.[Member] IS NULL)' Options='23' TimeRefreshed='2009-11-03T00:01:52' Name='DataRecordset-18' NextRowID='2' RowOrder='1' RefreshNoReconciliationUI='1' Checksum='1193713022'><vx:ADOData><xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
</vx:ADOData><vx:DataColumns><vx:DataColumn ColumnNameID='Member' Name='_VisDM_Member' Label='Member' LangID='1033' DataType='2' Currency='11' DisplayOrder='0'/><vx:DataColumn ColumnNameID='Count' Name='_VisDM_Count' Label='Count' LangID='1033' DataType='2' Currency='11' DisplayOrder='1'/><vx:DataColumn ColumnNameID='Request ID' Name='_VisDM_Request_ID' Label='Request ID' LangID='1033' DataType='2' Currency='11' DisplayOrder='2'/><vx:DataColumn ColumnNameID='Request ID(Avg)' Name='_VisDM_Request_IDAvg' Label='Request ID(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='3'/><vx:DataColumn ColumnNameID='Open Date(Min)' Name='_VisDM_Open_DateMin' Label='Open Date(Min)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='4'/><vx:DataColumn ColumnNameID='Open Date(Max)' Name='_VisDM_Open_DateMax' Label='Open Date(Max)' LangID='1033' DataType='5' UnitType='DATE' Currency='11' DisplayOrder='5'/><vx:DataColumn ColumnNameID='Open Length' Name='_VisDM_Open_Length' Label='Open Length' LangID='1033' DataType='2' Currency='11' DisplayOrder='6'/><vx:DataColumn ColumnNameID='Open Length(Avg)' Name='_VisDM_Open_LengthAvg' Label='Open Length(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='7'/><vx:DataColumn ColumnNameID='Resumes Submitted' Name='_VisDM_Resumes_Submitted' Label='Resumes Submitted' LangID='1033' DataType='2' Currency='11' DisplayOrder='8'/><vx:DataColumn ColumnNameID='Resumes Submitted(Avg)' Name='_VisDM_Resumes_SubmittedAvg' Label='Resumes Submitted(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='9'/><vx:DataColumn ColumnNameID='Phone Screens' Name='_VisDM_Phone_Screens' Label='Phone Screens' LangID='1033' DataType='2' Currency='11' DisplayOrder='10'/><vx:DataColumn ColumnNameID='Phone Screens(Avg)' Name='_VisDM_Phone_ScreensAvg' Label='Phone Screens(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='11'/><vx:DataColumn ColumnNameID='Interviews' Name='_VisDM_Interviews' Label='Interviews' LangID='1033' DataType='2' Currency='11' DisplayOrder='12'/><vx:DataColumn ColumnNameID='Interviews(Avg)' Name='_VisDM_InterviewsAvg' Label='Interviews(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='13'/><vx:DataColumn ColumnNameID='Offers' Name='_VisDM_Offers' Label='Offers' LangID='1033' DataType='2' Currency='11' DisplayOrder='14'/><vx:DataColumn ColumnNameID='Offers(Avg)' Name='_VisDM_OffersAvg' Label='Offers(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='15'/><vx:DataColumn ColumnNameID='Starts' Name='_VisDM_Starts' Label='Starts' LangID='1033' DataType='2' Currency='11' DisplayOrder='16'/><vx:DataColumn ColumnNameID='Starts(Avg)' Name='_VisDM_StartsAvg' Label='Starts(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='17'/><vx:DataColumn ColumnNameID='Interviews/Offer' Name='_VisDM_InterviewsOffer' Label='Interviews/Offer' LangID='1033' DataType='2' Currency='11' DisplayOrder='18'/><vx:DataColumn ColumnNameID='Interviews/Offer(Avg)' Name='_VisDM_InterviewsOfferAvg' Label='Interviews/Offer(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='19'/><vx:DataColumn ColumnNameID='Offer Accept Rate' Name='_VisDM_Offer_Accept_Rate' Label='Offer Accept Rate' LangID='1033' DataType='2' Currency='11' DisplayOrder='20'/><vx:DataColumn ColumnNameID='Offer Accept Rate(Avg)' Name='_VisDM_Offer_Accept_RateAvg' Label='Offer Accept Rate(Avg)' LangID='1033' DataType='2' Currency='11' DisplayOrder='21'/></vx:DataColumns></vx:DataRecordSet></vx:DataRecordSets>
Arial Unicode MS
Symbol
Wingdings
Calibri
SimSun
PMingLiU
MS PGothic
Dotum
Sylfaen
Estrangelo Edessa
Vrinda
Shruti
Mangal
Tunga
Sendnya
Raavi
Dhenu
Latha
Gautami
Cordia New
Arial
Malgun Gothic
Times New Roman
Guide
TheDoc
Gesture Format
Project 1
msvNoAutoConnect
visUSEType
msvNoSubprocess
Basic
Connector
Default Svg Style
visDGVisible
visDGShowBorder
visDGHideText
visDGNextItemID
msvDGCalloutGap
visDGDefaultPos
visVersion
visDGCalloutItem
visDGMinBorderSize
msvThemeColors
msvThemeEffects
msvCalloutType
PercentFilled
FullBarWidth
FullBarHeight
BarLength
BarLeft
BarBottom
LabelPos
LabelText
ValuePos
ValueText
MiddleHeight
TopHeight
BottomHeight
LeftWidth
RightWidth
Margin
CalloutOffset
StripHeight
ThemeColor
ValueFormat
ThemeColor2
visDGStackHeight
LabelTextLangID
ValueTextLangID
visDGItemID
visDGUseMaster
visDGCalloutField
msvCalloutPropMin
msvCalloutPropMax
msvCalloutPropValuePosition
msvCalloutPropValueFormat
msvCalloutPropValueSize
msvCalloutPropLabelPosition
msvCalloutPropLabel
msvCalloutPropLabelSize
msvCalloutPropOffset
msvCalloutPropWidth
msvCalloutField
BarLabelWidth
BarRight
IdealWidth
TextWidth
ValueTextInside
HalfLineWeight
BorderType
FillType
LabelPosition
ValuePosition
CalloutMargin
UnitSample
TextSample
LabelPosition2
msvCalloutPropShowValue
msvCalloutPropBorder
msvCalloutPropFill
VOffsetPosition
VOffset
HAlign
msvCalloutPropVOffset
msvCalloutIconNumber
msvCalloutIconCount
visDGIconField
visDGCalloutIconNumber
visDGField0
visDGField1
visCalloutIconNumber
visDGField2
visDGField3
visDGField4
visDGField5
Request ID
visDGField6
visDGField7
visDGField8
visDGField9
visDGFieldA
visDGFieldB
visDGFieldC
visDGFieldD
Project 2
visDGFieldE
visDGFieldF
NeedleAngle
visDGField10
visDGField11
visDGField12
visDGField13
visDGField14
visDGField15
visDGField16
visDGField17
visDGField18
visDGField19
visDGField1A
visDGField1B
Unfilled
Pivot Node
Row_1
Row_2
Row_3
TextPos
visDDInfoShape
visDDBreakdownShape
visDDIsRoot
visDDHasChildren
visDDIsMerged
visDDIsTopN
visDDSelfShapeID
visDDParentBDShape
visDDInstanceIndex
visDDParentDDShape
msvLayoutSortIndex
visDDShapeType
visDDImageName
visDDRecordsetID
visDDQueryID
visDDNormQueryStr
visDDParentBDShapeRef
visDDBreakdownShapeRef
visHasText
visDGDisplayFormat
msvLayoutIncludeSubshapes
visDDMergedTitle
visDDTitle
visDDOverlayOkay
visDDOriginalImage
Pivot Breakdown
visDDParentShape
visDDIsRootBD
visDDColumnIndex
visDDTopNNormQueryStr
visDDGraphicMasterID
visDDShapeImageMasterID
visDDIsSortedBD
visDDBDRefPntErr
visDDDeltaX
visDDDeltaY
visDDSortIndexCounter
Row_4
visDDShapePos
Pivot Info
visDDRootShape
visDDTitleShape
visDDConnectionID
visDDEncodedSchema
visDDConnectionString
visDDInitQueryString
visDDLastRefreshTime
visDDDocGUID
Pivot Title
visDDIsTitleShape
Pivot connector
visDDConnHideAlways
visDDTrackX
visDDTrackY
visDDNormalAngle
Data Table 1
msvLastAppliedDataGraphic
Row_5
_VisDM_Member
_VisDM_Count
_VisDM_Request_ID
_VisDM_Request_IDAvg
_VisDM_Open_DateMin
_VisDM_Open_DateMax
_VisDM_Open_Length
_VisDM_Open_LengthAvg
_VisDM_Resumes_Submitted
_VisDM_Resumes_SubmittedAvg
_VisDM_Phone_Screens
_VisDM_Phone_ScreensAvg
_VisDM_Interviews
_VisDM_InterviewsAvg
_VisDM_Offers
_VisDM_OffersAvg
_VisDM_Starts
_VisDM_StartsAvg
_VisDM_InterviewsOffer
_VisDM_InterviewsOfferAvg
_VisDM_Offer_Accept_Rate
_VisDM_Offer_Accept_RateAvg
Border rectangle
msvDGPosition
Row_6
Row_7
Row_8
Row_9
Row_10
Row_11
Row_12
Row_13
Row_14
Row_15
Row_16
Row_17
Row_18
Row_19
Question icon
visDGField21
visDGField22
Pivot Node.36
Pivot Node.48
visDGField23
Pivot Node.76
Pivot Node.88
Pivot Node.117
Pivot Node.130
Pivot Node.143
visSSSpecID
SkinColor
visSSTXT
Human resources.24
Human resources_2
visDGField25
visDGField26
visDGField27
visDGField28
Outer list
msvShapeCategories
msvStructureType
msvSDContainerMargin
msvSDContainerResize
msvSDContainerLocked
msvSDContainerNoHighlight
msvSDContainerNoRibbon
msvSDContainerStyle
msvSDContainerStyleCount
msvSDContainerRequiredCategories
msvSDHeadingStyle
msvSDHeadingStyleCount
msvSDMembersOnHiddenLayer
msvSDListRequiredCategories
msvSDListDirection
msvSDListSpacing
visAutoExpand
msvDGLegendShapeType
msvDGLegendText
HTxtMargin
msvSDContainerHeadingEdge
Field container
Inner list
msvSDListExcludedCategories
msvSDListAlignment
Icon item
msvDGLegendIconWidth
msvDGLegendIconHeight
Recruiters
Pivot Node.21
Pivot Node.27
Pivot Node.50
Pivot Node.56
Person - torso.30
Person - torso_2
Pivot Node.116
Pivot Node.158
Pivot Node.183
Pivot Node.225
Pivot Node.246
Outer list.31
Field container.32